package com.xxxx.server.page;


import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.metadata.BaseRowModel;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;


import java.io.Serializable;
import java.time.LocalDate;
import java.util.Date;


/**
 * Excel 导入到数据库中的实体
 */

@Data
public class EmployeeExcel extends BaseRowModel implements Serializable {

    @ApiModelProperty(value = "员工编号")
    @ExcelProperty("员工编号")
    @TableId(value = "id", type = IdType.AUTO)
    private String id;

    @ApiModelProperty(value = "员工姓名")
    @ExcelProperty("员工姓名")
    private String name;

    @ApiModelProperty(value = "性别")
    @ExcelProperty("性别")
    private String gender;

    @ApiModelProperty(value = "出生日期")
    //@ExcelProperty(value = "出生日期" ,converter = LocalDateTimeConverter.class)
    @ExcelProperty(value = "出生日期" )
    @JsonFormat(pattern = "yyyy/MM/dd HH:mm:ss", timezone = "GMT+8")
    private String birthday;

    @ApiModelProperty(value = "身份证号")
    @ExcelProperty("身份证号")
    private String idCard;

    @ApiModelProperty(value = "婚姻状况")
    @ExcelProperty("婚姻状况")
    private String wedlock;

    @ApiModelProperty(value = "民族")
    @ExcelProperty("民族")
    private String nationId;

    @ApiModelProperty(value = "籍贯")
    @ExcelProperty("籍贯")
    private String nativePlace;

    @ApiModelProperty(value = "政治面貌")
    @ExcelProperty("政治面貌")
    private String politicId;

    @ApiModelProperty(value = "邮箱")
    @ExcelProperty("邮箱")
    private String email;

    @ApiModelProperty(value = "电话号码")
    @ExcelProperty("电话号码")
    private String phone;

    @ApiModelProperty(value = "联系地址")
    @ExcelProperty("联系地址")
    private String address;

    @ApiModelProperty(value = "所属部门")
    @ExcelProperty("所属部门")
    private String departmentId;

    @ApiModelProperty(value = "职称ID")
    @ExcelProperty("职称ID")
    private String jobLevelId;

    @ApiModelProperty(value = "职位ID")
    @ExcelProperty("职位ID")
    private String posId;

    @ApiModelProperty(value = "聘用形式")
    @ExcelProperty("聘用形式")
    private String engageForm;

    @ApiModelProperty(value = "最高学历")
    @ExcelProperty("最高学历")
    private String tiptopDegree;

    @ApiModelProperty(value = "所属专业")
    @ExcelProperty("所属专业")
    private String specialty;

    @ApiModelProperty(value = "毕业院校")
    @ExcelProperty("毕业院校")
    private String school;

    @ApiModelProperty(value = "入职日期")
    //@ExcelProperty(value = "入职日期" ,converter = LocalDateTimeConverter.class)
    @ExcelProperty(value = "入职日期" )
    @JsonFormat(pattern = "yyyy/MM/dd HH:mm:ss", timezone = "GMT+8")
    private String beginDate;

    @ApiModelProperty(value = "在职状态")
    @ExcelProperty("在职状态")
    private String workState;

    @ApiModelProperty(value = "工号")
    @ExcelProperty("工号")
    private String workID;

    @ApiModelProperty(value = "合同期限")
    @ExcelProperty("合同期限")
    private String contractTerm;

    @ApiModelProperty(value = "转正日期")
    //@ExcelProperty(value = "转正日期" ,converter = LocalDateTimeConverter.class)
    @ExcelProperty(value = "转正日期" )
    @JsonFormat(pattern = "yyyy/MM/dd HH:mm:ss", timezone = "GMT+8")
    private String conversionTime;

    @ApiModelProperty(value = "离职日期")
    //@ExcelProperty(value = "离职日期" ,converter = LocalDateTimeConverter.class)
    @ExcelProperty(value = "离职日期" )
    @JsonFormat(pattern = "yyyy/MM/dd HH:mm:ss", timezone = "GMT+8")
    private String notWorkDate;

    @ApiModelProperty(value = "合同起始日期")
    @ExcelProperty(value = "合同起始日期")
    //@ExcelProperty(value = "合同起始日期",converter = LocalDateTimeConverter.class)
    @JsonFormat(pattern = "yyyy/MM/dd HH:mm:ss", timezone = "GMT+8")
    private String beginContract;

    @ApiModelProperty(value = "合同终止日期")
    //@ExcelProperty(value = "合同终止日期",converter = LocalDateTimeConverter.class)
    @ExcelProperty(value = "合同终止日期")
    @JsonFormat(pattern = "yyyy/MM/dd HH:mm:ss", timezone = "GMT+8")
    private String endContract;

    @ApiModelProperty(value = "工龄")
    @ExcelProperty("工龄")
    private String workAge;

    @ApiModelProperty(value = "工资账套ID")
    @ExcelProperty("工资账套ID")
    private String salaryId;

}
